Tabela LPerfResPerfContrServ

Definicja tabeli LPerfResPerfContrServ

Name

LPerfResPerfContrServ

Code

LPerfResPerfContrServ

Comment

 


Lista kolumn tabeli LPerfResPerfContrServ

Name

Code

LPerfResPerfContrServID

LPerfResPerfContrServID

PatientAgreementTypeID

PatientAgreementTypeID

ContractServID

ContractServID

PerfResourceID

PerfResourceID

ContractServicePerfID

ContractServicePerfID

TreatmentSchemaID

TreatmentSchemaID

DoseCalcMethodID

DoseCalcMethodID

StockItemQuantityID

StockItemQuantityID

ContractPrice

ContractPrice

ParamValue

ParamValue

IsGivenToPatient

IsGivenToPatient

TreatmentDayNo

TreatmentDayNo

AgreementNo

AgreementNo

UnitPrice

UnitPrice

ContractID

ContractID

RealUnitsCount

RealUnitsCount

ImportedDrugUnitPrice

ImportedDrugUnitPrice

LotInStID

LotInStID


Kolumna LPerfResPerfContrServID tabeli LPerfResPerfContrServ

Definicja kolumny LPerfResPerfContrServID tabeli LPerfResPerfContrServ

Name

LPerfResPerfContrServID

Code

LPerfResPerfContrServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientAgreementTypeID tabeli LPerfResPerfContrServ

Definicja kolumny PatientAgreementTypeID tabeli LPerfResPerfContrServ

Name

PatientAgreementTypeID

Code

PatientAgreementTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServID tabeli LPerfResPerfContrServ

Definicja kolumny ContractServID tabeli LPerfResPerfContrServ

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfResourceID tabeli LPerfResPerfContrServ

Definicja kolumny PerfResourceID tabeli LPerfResPerfContrServ

Name

PerfResourceID

Code

PerfResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServicePerfID tabeli LPerfResPerfContrServ

Definicja kolumny ContractServicePerfID tabeli LPerfResPerfContrServ

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TreatmentSchemaID tabeli LPerfResPerfContrServ

Definicja kolumny TreatmentSchemaID tabeli LPerfResPerfContrServ

Name

TreatmentSchemaID

Code

TreatmentSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DoseCalcMethodID tabeli LPerfResPerfContrServ

Definicja kolumny DoseCalcMethodID tabeli LPerfResPerfContrServ

Name

DoseCalcMethodID

Code

DoseCalcMethodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StockItemQuantityID tabeli LPerfResPerfContrServ

Definicja kolumny StockItemQuantityID tabeli LPerfResPerfContrServ

Name

StockItemQuantityID

Code

StockItemQuantityID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator pojedynczego wydania w wypadku braku apteki CGM i uzywania apteczek oddzialowych


Kolumna ContractPrice tabeli LPerfResPerfContrServ

Definicja kolumny ContractPrice tabeli LPerfResPerfContrServ

Name

ContractPrice

Code

ContractPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna ParamValue tabeli LPerfResPerfContrServ

Definicja kolumny ParamValue tabeli LPerfResPerfContrServ

Name

ParamValue

Code

ParamValue

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna IsGivenToPatient tabeli LPerfResPerfContrServ

Definicja kolumny IsGivenToPatient tabeli LPerfResPerfContrServ

Name

IsGivenToPatient

Code

IsGivenToPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna TreatmentDayNo tabeli LPerfResPerfContrServ

Definicja kolumny TreatmentDayNo tabeli LPerfResPerfContrServ

Name

TreatmentDayNo

Code

TreatmentDayNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AgreementNo tabeli LPerfResPerfContrServ

Definicja kolumny AgreementNo tabeli LPerfResPerfContrServ

Name

AgreementNo

Code

AgreementNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna UnitPrice tabeli LPerfResPerfContrServ

Definicja kolumny UnitPrice tabeli LPerfResPerfContrServ

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna ContractID tabeli LPerfResPerfContrServ

Definicja kolumny ContractID tabeli LPerfResPerfContrServ

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RealUnitsCount tabeli LPerfResPerfContrServ

Definicja kolumny RealUnitsCount tabeli LPerfResPerfContrServ

Name

RealUnitsCount

Code

RealUnitsCount

Data Type

NUMBER(15,4)

Mandatory

No

Comment

 


Kolumna ImportedDrugUnitPrice tabeli LPerfResPerfContrServ

Definicja kolumny ImportedDrugUnitPrice tabeli LPerfResPerfContrServ

Name

ImportedDrugUnitPrice

Code

ImportedDrugUnitPrice

Data Type

NUMBER(19,10)

Mandatory

No

Comment

 


Kolumna LotInStID tabeli LPerfResPerfContrServ

Definicja kolumny LotInStID tabeli LPerfResPerfContrServ

Name

LotInStID

Code

LotInStID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator pojedynczego wydania pacjentowi leku w aptece CGM


Lista kluczy tabeli LPerfResPerfContrServ

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPerfResPerfContrServ

Definicja klucza Identifier_1 tabeli LPerfResPerfContrServ

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment